Видео ютуба по тегу Cross Apply Sys.dm_Exec_Sql_Text

Find Currently Running Query on SQL Server
Find Currently Running Query on SQL Server
PlanCacheTsunami
PlanCacheTsunami